TIL

I keep learning something new every day. Sometimes, what I learn doesn't come to use immediately or frequently. However, I've decided to document the learnings that interested me the most for my future self.
You may find these posts not well written (bad sentence formations and spelling mistakes). That is intentional. It is to keep myself moving fast and to free myself for prefectionism.

2023

• 5 December

  Live reload of a webserver inside a docker container

  A neat way to go ahead when you have a broken environment (not your home)
• 30 November

  Python profiling

  How to get a line by line profile of a python function
• 29 November

  TEXT vs JSON vs JSONB column data types in postgres

  What data type to choose for storing dictionary information in postgres
• 21 November

  Retry, Wait, and Fallback

  A look at how to increase the reliability of your workflows
• 29 October

  Maintainable DevOps for AWS EC2

  Create and maintain EC2 instances with TF and carry out CI/CD with GH actions and Ansible
• 4 July

  Testing in Python

  Notes and lessons learned from writing tests in Python.
• 30 April

  Custom TLDs

  What I learned from my curiosity about creating custom TLDs
• 25 March

  Timeouts in Postgres RDS

  How to troubleshoot different kind of timeouts in Postgres
• 25 February

  GitLab CI/CD Intermediate

  Some basic to intermediate level concepts of GitLab CI/CD
• 19 February

  Sync data between two k8s clusters

  Some useful commands and notes on how to sync data between two DBs of different clusters
• 5 January

  Platform Engineering

  Notes on what platform engineering is about and how it differs from Devops/SRE/SDE

2022

• 17 November

  Batch processing long running SQL queries

  Reliable code snippets to use whenever there is a need to download huge datasets in batches
• 17 October

  Software Deployment Stratagies

  Notes on Blue Green v/s Canary v/s A/B deployment stratagies
• 4 October

  Notes on ArgoCD

  Beginners introduction to Argo CD and its advantages over alternatives
• 2 October

  GitLab CI/CD basics

  Some basic hidden workings of GitLab CI/CD I discovered recently
• 29 September

  Characteristics of Materiliazed Views

  Some pointers on when to use them and when to not
• 25 September

  Application DB v/s Warehouse DB

  Notes on why a Warehouse DB is needed in addition to the application DB
• 25 September

  Explain Analyze

  Profiling SQL queries on Postgres